![]() |
![]() |
When dynamically generated list has
been selected as a parameter, a parameter resolution engine generates
the following screen:
You can clearly see the list of
available values in this list. The entire list has been generated in the
runtime, using the information supplied during the definition phase of this
parameter.
Remember, we wanted to get all
available measure captions (for display values) and corresponding measure unique
names (for substitution values). Therefore, Cube PLAYER used the supplied
connection string to establish the actual OLAP connection to the selected server
and database (not necessarily the same one as we are currently working on) and,
once a connection has been successfully opened, it
executed the supplied MDX SELECT command.
The end-user has a simple choice of
selecting one of the existing items. In this example, we shall select the Store Sales Net (last one) and click on
the Accept
button.
When a new selection has been made,
the new substitution value is immediately indicated in the Set MDX parameters
dialog: